Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
OBJ VARCHAR2(20) No null 1 null NO NO NO
ID VARCHAR2(100) Yes null 2 null NO NO NO
TITLE VARCHAR2(400) Yes null 3 null NO NO NO
CREATED_ON DATE Yes null 4 null NO NO NO
STATUS VARCHAR2(100) Yes null 5 null NO NO NO
LEAD VARCHAR2(400) Yes null 6 null NO NO NO
OWNING_UNIT VARCHAR2(400) Yes null 7 null NO NO NO
CREATE_UNIT VARCHAR2(400) Yes null 8 null NO NO NO
RCV_UNIT VARCHAR2(400) Yes null 9 null NO NO NO
REFERRAL_TYPE VARCHAR2(100) No null 10 null NO NO NO
NEXT_DUE_DATE DATE Yes null 11 null NO NO NO
FINAL_DUE_DATE DATE Yes null 12 null NO NO NO
CREATED_ON_FY NUMBER Yes null 13 null NO NO NO
LAST_MODIFIED_DATE DATE Yes null 14 null NO NO NO
SOURCE VARCHAR2(4000) Yes null 15 null NO NO NO
SUBJECTS VARCHAR2(4000) Yes null 16 null NO NO NO
OFFICE VARCHAR2(4000) Yes null 17 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CUBE_PARTIC_OUTCOMES_INTERCOMS VIEW QART V_CUBE_INTERCOM_ALL VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CUBE_INTERCOM_ALL VIEW QART MV_ACM_OBJ TABLE
QART V_CUBE_INTERCOM_ALL VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_CUBE_INTERCOM_ALL VIEW QART V_CURR_OBJ_LEAD_PERS VIEW
QART V_CUBE_INTERCOM_ALL VIEW QART MV_ACM_REFERENCE TABLE
QART V_CUBE_INTERCOM_ALL VIEW QART V_CURR_OBJ_OWNING_UNIT VIEW
QART V_CUBE_INTERCOM_ALL VIEW QART V_CURR_OBJ_CREATE_UNIT VIEW
QART V_CUBE_INTERCOM_ALL VIEW QART V_CURR_OBJ_RECEIVING_UNIT VIEW
QART V_CUBE_INTERCOM_ALL VIEW QART MV_I_REFERRAL TABLE
QART V_CUBE_INTERCOM_ALL VIEW QART MV_ACM_STATUS TABLE
QART V_CUBE_INTERCOM_ALL VIEW QART MV_ACM_STATUS_HISTORY TABLE
QART V_CUBE_INTERCOM_ALL VIEW QART V_OBJ_PARTICIPANTS VIEW
NAME VALUE
CREATED 04-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_CUBE_INTERCOM_ALL
TEXT_LENGTH 1944
TEXT select o.sid obj,           o.id id,           o.tagline title,           o.created_on,           stat.display status,           lead.sh_display lead,           ou.sh_display owning_unit,           cu.sh_display create_unit,           ru.sh_display rcv_unit,           ot.display referral_type,           o.next_due_date,           o.final_due_date,           o.created_on_fy created_on_fy,           o.last_modified_on last_modified_date,           ref.display source,           OP.SUBJECTS,           OP.OFFICE      from mv_acm_obj o           inner join mv_acm_obj_type ot              on o.obj_type = ot.sid and ot.obj_root in ('INTERCOM')           left outer join (select obj, sh_obj, sh_display from v_curr_obj_lead_pers) lead              on lead.obj = o.sid           left outer join (select obj, sh_obj, sh_display from v_curr_obj_owning_unit) ou              on ou.obj = o.sid           left outer join (select obj, sh_obj, sh_display from v_curr_obj_create_unit) cu              on cu.obj = o.sid           left outer join (select obj, sh_obj, sh_display from v_curr_obj_receiving_unit) ru              on ru.obj = o.sid           left outer join mv_acm_status_history vs              on vs.obj = o.sid and vs.completed_on is null           inner join mv_acm_status stat              on stat.sid = vs.status           left outer join (select ir.obj, ar.display                              from    mv_i_referral ir                                   left outer join                                      mv_acm_reference ar                                   on ir.orig_receipt_method = ar.ref_key) ref              on ref.obj = o.sid         LEFT OUTER JOIN (SELECT OBJ,     LISTAGG(PARTIC_OBJ, ';' || chr(10)) WITHIN GROUP( ORDER BY INVOLV_SID ) SUBJECTS,     LISTAGG(OFFICE,chr(10)) WITHIN GROUP ( ORDER BY PARTICIPANT_NAME ) OFFICE     FROM V_OBJ_PARTICIPANTS      WHERE CODE = 'SUBJECT'     GROUP BY OBJ     ) OP ON OP.OBJ = O.SID
TEXT_VC select o.sid obj,           o.id id,           o.tagline title,           o.created_on,           stat.display status,           lead.sh_display lead,           ou.sh_display owning_unit,           cu.sh_display create_unit,           ru.sh_display rcv_unit,           ot.display referral_type,           o.next_due_date,           o.final_due_date,           o.created_on_fy created_on_fy,           o.last_modified_on last_modified_date,           ref.display source,           OP.SUBJECTS,           OP.OFFICE      from mv_acm_obj o           inner join mv_acm_obj_type ot              on o.obj_type = ot.sid and ot.obj_root in ('INTERCOM')           left outer join (select obj, sh_obj, sh_display from v_curr_obj_lead_pers) lead              on lead.obj = o.sid           left outer join (select obj, sh_obj, sh_display from v_curr_obj_owning_unit) ou              on ou.obj = o.sid           left outer join (select obj, sh_obj, sh_display from v_curr_obj_create_unit) cu              on cu.obj = o.sid           left outer join (select obj, sh_obj, sh_display from v_curr_obj_receiving_unit) ru              on ru.obj = o.sid           left outer join mv_acm_status_history vs              on vs.obj = o.sid and vs.completed_on is null           inner join mv_acm_status stat              on stat.sid = vs.status           left outer join (select ir.obj, ar.display                              from    mv_i_referral ir                                   left outer join                                      mv_acm_reference ar                                   on ir.orig_receipt_method = ar.ref_key) ref              on ref.obj = o.sid         LEFT OUTER JOIN (SELECT OBJ,     LISTAGG(PARTIC_OBJ, ';' || chr(10)) WITHIN GROUP( ORDER BY INVOLV_SID ) SUBJECTS,     LISTAGG(OFFICE,chr(10)) WITHIN GROUP ( ORDER BY PARTICIPANT_NAME ) OFFICE     FROM V_OBJ_PARTICIPANTS      WHERE CODE = 'SUBJECT'     GROUP BY OBJ     ) OP ON OP.OBJ = O.SID
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT